The Pulse of NYC: Weather, Events, and the Subway
Welcome
New York City is a living organism, and the subway is its circulatory system. But what happens when that system is stressed?
This project explores how Extreme Weather (from heat waves to nor’easters) and Mega-Events (like the Marathon and Pride) alter the rhythm of the city. By analyzing over 2 million hourly ridership records from 2024-2025, we uncover the hidden patterns of the daily commute.
Explore the Project
- Analysis: See our four data stories—The Goldilocks Zone, The Event Blast Radius, Station Personalities, and Rain Sensitivity.
- Data & Methods: How we wrangled 21 million rows of data down to a usable panel.
- Report: The full academic report detailing our motivation, methods, and findings.
- GitHub Repository: View the source code and data.
Project Screencast
Accessibility
All visualizations in this project use the Okabe-Ito color palette to ensure readability for viewers with color vision differences.
The Team
- William M. Donovan (wd2328)
- Hantang Qin (hq2229)
- Yongyan Liu (yl6107)
- Yijun Wang (yw4664)
- Heng Hu (hh2648)
P8105 Data Science I | Fall 2025
Columbia University Mailman School of Public Health
Department of Biostatistics